
********************************************************
***   This file merges all the wage data from CPS    ***
********************************************************

* Read wage for cpkt 
use "$temp/wage_CCPSKT_data.dta"
rename HW_CCPSKT cps_cpkt 

* Merge with cc data
merge 1:1 state_year using "$temp/wage_CC_data.dta"
drop _merge
rename HW_CC cps_cc


keep year state cps_cpkt cps_cc  state_year
order year state cps_cpkt cps_cc  state_year


save "$temp/wage_raw.dta", replace

clear 
